Handling dataframe columns names

1 clear columns names with clean_names()

Code

library(tidyverse)
library(janitor)

Code

# make data001
data001=data.frame(v1=c(1,2,3),V2=seq(3),V3=seq(3))
colnames(data001) <- c('first Column', 'The secound','something_else')

Code

data001%>% names()  

[1] "first Column"   "The secound"    "something_else"

Code

data002=data001 %>% clean_names()
data002%>% names()  

[1] "first_column"   "the_secound"    "something_else"

2 change one column names

New column names=old column name

Code

data003=data002 %>% rename('secound_column'='the_secound') 
data003%>% names()

[1] "first_column"   "secound_column" "something_else"

3 change multiple column names

change all column to upper

Code

data003 %>% rename_with(toupper) %>% names()

[1] "FIRST_COLUMN"   "SECOUND_COLUMN" "SOMETHING_ELSE"

change all column end with ’column ’to upper

Code

data003 %>% rename_with(toupper,ends_with('column')) %>% names()

[1] "FIRST_COLUMN"   "SECOUND_COLUMN" "something_else"

change all column end with ‘column’ from _ to .

Code

data003 %>% rename_with(~gsub('_','.',.x),ends_with('column')) %>% names()

[1] "first.column"   "secound.column" "something_else"

4 Reference

https://www.youtube.com/watch?v=MhCTjM3xHZY